Sharepoint calculated value reference other column. Jun 17, 2024 · I'm trying to create a calculated column based on a status column. If you need to set a default value based on another column, and still have that user editable, you can use workflow, or use Javascript / jQuery to set the field. For more information on calculated columns and functions, see Calculate data in lists or libraries. Note: Calculated fields can only operate on their own row, so you can't reference a value in another row, or columns contained in another list or library. The “Display Name” needs to reflect what you want to see in the drop down menu that corresponds with that other data you need. The “Value” needs to reflect the data that you are looking to reference. Jan 27, 2026 · At the moment, only Calculated column types support using formulas that reference data from other columns within the same list or library. I have tried an IF statement that looks something like this =IF [Team You can use formulas and functions in lists or libraries to calculate data in a variety of ways. Jun 24, 2020 · In SharePoint online, it's not supported that formula contains reference to other fields when setting column default value. As a SharePoint developer, I have created calculated columns in SharePoint lists and libraries many times when we want to display column values based on formulas. nme frwzt ohkd vcam lrlno aeck ijbjf pqsnai bohi rdfzjmy